﻿CREATE VIEW dbo.VIEW_SEARCH_NSI_SERVICE
AS
SELECT        dbo.NSI_SERVICE.ID, dbo.NSI_SERVICE.CODE, dbo.NSI_SERVICE.SHORT_NAME, dbo.NSI_SERVICE.FULL_NAME, 
                         dbo.NSI_METER.SHORT_NAME AS NSI_METER_NAME, 1 AS COUNT, dbo.NSI_SERVICE.NSI_METER_ID
FROM            dbo.NSI_SERVICE LEFT OUTER JOIN
                         dbo.NSI_METER ON dbo.NSI_SERVICE.NSI_METER_ID = dbo.NSI_METER.ID